SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_DeleteSpeciality]
(
	@fdSpecID VARCHAR(50)
)
AS
DELETE FROM dbo.FS_Speciality WHERE fdSpecID=@fdSpecID
DELETE FROM dbo.JOL_SpecialityIntroduction WHERE fdSpecID=@fdSpecID
GO
